Release 10.1A: OpenEdge Data Management:
Database Administration

Adding schema to a void database

When you use the PROSTRCT CREATE utility on a .st file, the resulting database files are referred to as a void database. A void database does not contain any OpenEdge RDBMS metaschema. The void database consists of the .db extent and whatever .bi, .ai, .tl, and .dn extents you defined in the .st file. You must add metaschema information to a void database. The OpenEdge RDBMS provides an empty database in the size of each supported database block size for this purpose.

To add metaschema information to a void database:

Use the PROCOPY utility to copy the system tables from an empty OpenEdge database into the void database you created with PROSTRCT CREATE:

procopy $DLC/emptyn db-name

where emptyn is the source database and db-name is the target database. n indicates the block size of the OpenEdge-supplied empty.db. See the "PRODB utility" section for more information about the empty and emptyn databases.

Note: The DLC directory in Windows is: %DLC%.
Use the PROSTRCT LIST utility to verify that you have the correct database files in the correct locations:

prostrct list db-name

Caution: If you do not specify an output file when using PROSTRCT LIST, your existing .st file will be overwritten to reflect the current structure.
Use the Data Dictionary to load the existing user tables (.df file) into your database.
Note: The empty .db file and the database you want copied to it must have the same block size. Similarly, if the blocks per cluster token was used with any data areas, the data areas of the empty .db file and those of the database you want copied to it must have the same blocks per cluster value.